/*
 Navicat Premium Data Transfer

 Source Server         : MacOS MySQL 5.7
 Source Server Type    : MySQL
 Source Server Version : 50735
 Source Host           : localhost:3306
 Source Schema         : se

 Target Server Type    : MySQL
 Target Server Version : 50735
 File Encoding         : 65001

 Date: 16/10/2021 13:59:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for login_detail
-- ----------------------------
DROP TABLE IF EXISTS `login_detail`;
CREATE TABLE `login_detail` (
                                `id` int(11) NOT NULL,
                                `student_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                `token` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of login_detail
-- ----------------------------
BEGIN;
INSERT INTO `login_detail` VALUES (1, '1234', '5678');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


-- ----------------------------
-- Table structure for connection_detail
-- ----------------------------
DROP TABLE IF EXISTS `connection_detail`;
CREATE TABLE `connection_detail` (
                                     `id` int(11) NOT NULL,
                                     `student_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                     `course_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of connection_detail
-- ----------------------------
BEGIN;
INSERT INTO `connection_detail` VALUES (1, '1234', '111');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

-- ----------------------------
-- Table structure for connection_detailPK
-- ----------------------------
DROP TABLE IF EXISTS `connection_detailPK`;
CREATE TABLE `connection_detailPK` (
                                       `id` int(11) NOT NULL,
                                       `student_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                       `course_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                       PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of connection_detailPK
-- ----------------------------
BEGIN;
INSERT INTO `connection_detailPK` VALUES (1, '1234', '111');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


-- ----------------------------
-- Table structure for course_detail
-- ----------------------------
DROP TABLE IF EXISTS `course_detail`;
CREATE TABLE `course_detail` (
                                 `id` int(11) NOT NULL,
                                 `course_id` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                 `course_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                 `school_term` tinyint COLLATE utf8_bin DEFAULT NULL,
                                 `class_hour` int COLLATE utf8_bin DEFAULT NULL,
                                 `credit` int COLLATE utf8_bin DEFAULT NULL,

                                 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of course_detail
-- ----------------------------
BEGIN;
INSERT INTO `course_detail` VALUES (1, '1234', 'Java开发实验',1, 60, 3);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


-- ----------------------------
-- Table structure for major_detail
-- ----------------------------
DROP TABLE IF EXISTS `major_detail`;
CREATE TABLE `major_detail` (
                                `id` int(11) NOT NULL,
                                `major_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                `people_number` int COLLATE utf8_bin DEFAULT NULL,
                                `leader` varchar(255) COLLATE utf8_bin DEFAULT NULL,

                                PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of major_detail
-- ----------------------------
BEGIN;
INSERT INTO `major_detail` VALUES (1, 'Java开发实验', 48, '李老师');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;


-- ----------------------------
-- Table structure for student_information_detail
-- ----------------------------
DROP TABLE IF EXISTS `student_information_detail`;
CREATE TABLE `student_information_detail` (
                                              `id` int(11) NOT NULL,
                                              `student_no` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                              `student_name` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                              `gender` tinyint COLLATE utf8_bin DEFAULT NULL,
                                              `birthday` varchar(255) COLLATE utf8_bin DEFAULT NULL,
                                              `total_score` int COLLATE utf8_bin DEFAULT NULL,
                                              `remark` varchar(255) COLLATE utf8_bin DEFAULT NULL,

                                              PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of student_information_detail
-- ----------------------------
BEGIN;
INSERT INTO `student_information_detail` VALUES (1, '1234', '小杨同学',3,'2000-10-09', 490, '5');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
